package org.spring.springboot.dao;

import org.spring.springboot.entity.VisitorSubscribe;

import java.sql.Timestamp;
import java.util.List;
import java.util.Map;

public interface VisitorSubscribeDao {

    List<Map<String, Object>> selectBysubscribe(String visitorname);

    List<Map<String, Object>> selectBysubscribe1(String visitorname);

    List<Map<String, Object>> selectBysubscribe2(String visitorname);

    int interviewee_manage(Integer intervieweeId,Integer id,String remark1);

    int department_manage(Integer departmentId,String departmentName,Integer id,String remark2);

    int subscribe_complete(Integer complete,Integer id);

    List<Map<String, Object>> selectInvite(Integer id);

    List<Map<String, Object>> selectByStatus(String visitorname);

    List<Map<String, Object>> selectHistoryRecord(Timestamp starttime,Timestamp endtime,Integer id);

    String selectIntervieweeName(Integer id);

    List<Map<String, Object>> selectvisitorTeg(Integer fid);

    List<Map<String, Object>> selectBysubscribeNum();

    List<Map<String, Object>> selectBysubscribe1Num();

    List<Map<String, Object>> selectBysubscribe2Num();

    List<Map<String, Object>> selectBysubscribeDetail();

}
